| Campus |
| EntityType | Independent |
| Logical Entity Name | Campus |
| Default Table Name | SyCampus |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| Campus Attributes |
| Campus Keys |
| Key Name | Key Type | Keys |
| SyCampus_SyCampusID_U_C_IDX | PrimaryKey | CampusId |
| SyCampus_SaRefundPolicyID_N_N_IDX | Inversion Entry | SaRefundPolicyID |
| SyCampus_TransSaSyStaffID_N_N_IDX | Inversion Entry | TransferSaTaskStaffId |
| SyCampus_SaGLExportFileDefinitionID_N_N_IDX | Inversion Entry | GeneralLedgerExportFileDefinitionId |
| SyCampus_OnlinePaymentUserID_N_N_IDX | Inversion Entry | OnlinePaymentUserID |
| SyCampus_ISIRVerGroupID_N_N_IDX | Inversion Entry | IsirVerificationStudentGroupId |
| SyCampus_ISIRCGroupID_N_N_IDX | Inversion Entry | IsirCCodeStudentGroupId |
| SyCampus_Code_N_N_IDX | Inversion Entry | Code |
| SyCampus_TransSaCmTemplateID_N_N_IDX | Inversion Entry | TransferSaTaskTemplateId |
| SyCampus_TransFaSyStaffID_N_N_IDX | Inversion Entry | TransferFaTaskStaffId |
| SyCampus_TransFaCmTemplateID_N_N_IDX | Inversion Entry | TransferFaTaskTemplateId |
| SyCampus_SyQuickLeadTemplateID_N_N_IDX | Inversion Entry | SyQuickLeadTemplateID |
| SyCampus_SyPaymentAccountID_N_N_IDX | Inversion Entry | PaymentProcessorAccountId |
| SyCampus_RptEntityID_N_N_IDX | Inversion Entry | RptEntityIdentifier |
| SyCampus_SyCampusId_Code_U_N_IDX | Alternate Key | CampusId, Code |
| Campus Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| StudentGroup | Non-Identifying | Zero or One to Zero or More | IsirCCodeStudentGroupId | NO | |||
| StudentGroup | Non-Identifying | Zero or One to Zero or More | IsirVerificationStudentGroupId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | OnlinePaymentUserID | NO | |||
| GeneralLedgerExportFileDefinition | Non-Identifying | Zero or One to Zero or More | GeneralLedgerExportFileDefinitionId | NO | |||
| RefundCalculationPolicy | Non-Identifying | Zero or One to Zero or More | SaRefundPolicyID | NO | |||
| PaymentProcessorAccount | Non-Identifying | Zero or One to Zero or More | PaymentProcessorAccountId | NO | |||
| ProspectInquiryFormTemplate | Non-Identifying | Zero or One to Zero or More | SyQuickLeadTemplateID | NO | |||
| TaskTemplate | Non-Identifying | Zero or One to Zero or More | TransferFaTaskTemplateId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | TransferFaTaskStaffId | NO | |||
| TaskTemplate | Non-Identifying | Zero or One to Zero or More | TransferSaTaskTemplateId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | TransferSaTaskStaffId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| AchBatchFileSettingCampusAssociation | Non-Identifying | One To Zero or More | NO | ||||
| AttendancePostingPermission | Non-Identifying | One To Zero or More | NO | ||||
| AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More | NO | ||||
| Bank | Non-Identifying | One To Zero or More | NO | ||||
| BillingMethodDetail | Non-Identifying | One To Zero or More | NO | ||||
| CashDrawerSession | Non-Identifying | One To Zero or More | NO | ||||
| CollegeCourseArticulationDetail | Non-Identifying | One To Zero or More | NO | ||||
| CreditCardBatchFileSettingCampusAssociation | Non-Identifying | One To Zero or More | NO | ||||
| EntranceTestImportFileSchemaEntranceTest | Non-Identifying | One To Zero or More | NO | ||||
| EntranceTestImportFileTestTypeCampus | Non-Identifying | One To Zero or More | NO | ||||
| GeneralLedgerLinkAccount | Non-Identifying | One To Zero or More | NO | ||||
| GeneralLedgerReleaseBatch | Non-Identifying | One To Zero or More | NO | ||||
| HighSchoolCourseArticulationDetail | Non-Identifying | One To Zero or More | NO | ||||
| HousingBuilding | Non-Identifying | One To Zero or More | NO | ||||
| Incident | Non-Identifying | One To Zero or More | NO | ||||
| MiscellaneousCash | Non-Identifying | One To Zero or More | NO | ||||
| MonthEndProcess | Non-Identifying | One To Zero or More | NO | ||||
| PendingApplicant | Non-Identifying | One To Zero or More | NO | ||||
| PendingEmployer | Non-Identifying | One To Zero or More | NO | ||||
| PendingProspectInquiry | Non-Identifying | One To Zero or More | NO | ||||
| ProspectInquiry | Non-Identifying | One To Zero or More | NO | ||||
| SevisCampusDetail | Non-Identifying | One To Zero or More | NO | ||||
| SevisStudentSiteActivity | Non-Identifying | One To Zero or More | NO | ||||
| Student | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountPendingTransaction | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountPendingTransactionCourse | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountTransaction | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountTransactionAppliedPayment | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountTransactionConfigureAppliedPayment | Non-Identifying | One To Zero or More | NO | ||||
| StudentBillingStatementBatch | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentPeriod | Non-Identifying | One To Zero or More | NO | ||||
| StudentRevenueSummaryChildTerm | Non-Identifying | One To Zero or More | NO | ||||
| StudentServicesLocation | Non-Identifying | One To Zero or More | NO | ||||
| StudentSubsidiaryAccountTransaction | Non-Identifying | One To Zero or More | NO | ||||
| StudentSubsidiaryStatement | Non-Identifying | One To Zero or More | NO | ||||
| SubsidiaryAccountTypeCampusDetail | Non-Identifying | One To Zero or More | NO | ||||
| TaskArchive | Non-Identifying | One To Zero or More | NO | ||||
| Staff | Non-Identifying | One To Zero or More | NO | ||||
| FaSSCR | Non-Identifying | One To Zero or More | NO | ||||
| AdAttendArchiveQueue | Non-Identifying | One To Zero or More | NO | ||||
| AdEnrollTermRelationshipException | Non-Identifying | One To Zero or More | NO | ||||
| GainfulEmploymentSetting | Non-Identifying | One To Zero or More | NO | ||||
| AdIPEDSDistEdCriteriaDetail | Non-Identifying | One To Zero or More | NO | ||||
| AdIPEDSDistEdCriteriaDetail | Non-Identifying | One To Zero or More | NO | ||||
| RegistrationGroupTerm | Non-Identifying | One To Zero or More | NO | ||||
| FaSapProcessQueueHeader | Non-Identifying | One To Zero or More | NO | ||||
| SchoolStartDateTerm | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentPeriodTransfer | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentPeriodTransfer | Non-Identifying | One To Zero or More | NO | ||||
| AdTermCampusRelationship | Non-Identifying | One To Zero or More | NO | ||||
| TermRegistrationSetting | Identifying | One To Zero or More | NO | ||||
| TermRelationshipDataChange | Non-Identifying | One To Zero or More | NO | ||||
| AmApplicant | Non-Identifying | One To Zero or More | NO | ||||
| CollegeCourseArticulationDetail | Non-Identifying | One To Zero or More | NO | ||||
| HighSchoolCourseArticulationDetail | Non-Identifying | One To Zero or More | NO | ||||
| EntranceTestImportFileTestTypeCampus | Non-Identifying | One To Zero or More | NO | ||||
| EntranceTestImportFileSchemaEntranceTest | Non-Identifying | One To Zero or More | NO | ||||
| CmDocLocation | Non-Identifying | One To Zero or More | NO | ||||
| Task | Non-Identifying | One To Zero or More | NO | ||||
| CmEventQueue | Non-Identifying | One To Zero or More | NO | ||||
| CmGlobalDocumentCampus | Identifying | One To Zero or More | NO | ||||
| Incident | Non-Identifying | One To Zero or More | NO | ||||
| AwardLetterPrintQueue | Non-Identifying | One To Zero or More | NO | ||||
| FundSourceDisabledAwardYear | Non-Identifying | One To Zero or More | NO | ||||
| FaAwardYearMaxAmt | Non-Identifying | One To Zero or More | NO | ||||
| FaExportImportFile | Non-Identifying | One To Zero or More | NO | ||||
| BatchPackagingProcess | Non-Identifying | One To Zero or More | NO | ||||
| FaCampusVantageWorkStudyPayroll | Non-Identifying | One To Zero or More | NO | ||||
| FaCashPlanConfigRelationship | Non-Identifying | One To Zero or More | NO | ||||
| FaCfpGrantOptionsConfig_Regulatory | Non-Identifying | One To Zero or More | NO | ||||
| DisbursementApprovalRuleCampusFundSource | Identifying | One To Zero or More | NO | ||||
| ExcusedAbsencePolicyCodeDetail | Non-Identifying | One To Zero or More | NO | ||||
| FaFundSourceAutoAwardRules | Non-Identifying | One To Zero or More | NO | ||||
| FundSourceLendingInstitution | Identifying | One To Zero or More | NO | ||||
| FaFundSourcePriority | Non-Identifying | One To Zero or More | NO | ||||
| FaGlAuthorizationCampus | Non-Identifying | One To Zero or More | NO | ||||
| FaMultiDisbSchedCampusCriteria | Non-Identifying | One To Zero or More | NO | ||||
| FaNoelLevitz | Non-Identifying | One To Zero or More | NO | ||||
| FaProgramVersionCOA | Non-Identifying | One To Zero or More | NO | ||||
| FaRepackageTriggerAssociation_Faa | Non-Identifying | One To Zero or More | NO | ||||
| FaRepackageTriggerConfigAssociation_FAA | Non-Identifying | One To Zero or More | NO | ||||
| FaShoppingSheet | Non-Identifying | One To Zero or More | NO | ||||
| FaShoppingSheetBannerInfo | Non-Identifying | One To Zero or More | NO | ||||
| FaShoppingSheetCommentsConfig | Non-Identifying | One To Zero or More | NO | ||||
| FaShoppingSheetCostsConfig | Non-Identifying | One To Zero or More | NO | ||||
| FaShoppingSheetLoanOptionsConfig | Non-Identifying | One To Zero or More | NO | ||||
| FaStudentAutoAwardLog | Non-Identifying | One To Zero or More | NO | ||||
| FaStudentMaster | Non-Identifying | One To Zero or More | NO | ||||
| FaTsmMain | Non-Identifying | One To Zero or More | NO | ||||
| HousingBuilding | Non-Identifying | One To Zero or More | NO | ||||
| HSRoomMateMatch | Non-Identifying | One To Zero or More | NO | ||||
| HousingApplicationStudent | Non-Identifying | One To Zero or More | NO | ||||
| PendingEmployer | Non-Identifying | One To Zero or More | NO | ||||
| AchBatchFileSettingCampusAssociation | Non-Identifying | One To Zero or More | NO | ||||
| SaAgeDaysConfiguration_Faa | Non-Identifying | One To Zero or More | NO | ||||
| AttendancePostingPermission | Non-Identifying | One To Zero or More | NO | ||||
| AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More | NO | ||||
| SaAutoCharge | Non-Identifying | One To Zero or More | NO | ||||
| SAAutoChargeProgramVersion | Non-Identifying | One To Zero or More | NO | ||||
| StudentBillingStatementBatch | Non-Identifying | One To Zero or More | NO | ||||
| SaCampusBillingResidencyTypeList | Non-Identifying | One To Zero or More | NO | ||||
| SaCampusVantageErrorLog | Non-Identifying | One To Zero or More | NO | ||||
| CreditCardTypeCampus | Identifying | One To Zero or More | NO | ||||
| SaDefaultIRPolicyConfiguration_FAA | Non-Identifying | One To Zero or More | NO | ||||
| SaDynamicsErrorLog | Non-Identifying | One To Zero or More | NO | ||||
| StudentRevenueSummaryChildTerm | Non-Identifying | One To Zero or More | NO | ||||
| SaFundSourceOrder | Non-Identifying | One To Zero or More | NO | ||||
| MonthEndProcess | Non-Identifying | One To Zero or More | NO | ||||
| SaNotificationConfiguration_Faa | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountTransactionAppliedPayment | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountTransactionConfigureAppliedPayment | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountPendingTransaction | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountPendingTransactionCourse | Non-Identifying | One To Zero or More | NO | ||||
| SaPendingChargeRecalcLog | Non-Identifying | One To Zero or More | NO | ||||
| PostWithdrawalDisbursementConfigurationDetail | Non-Identifying | One To Zero or More | NO | ||||
| SaPWDRoutingTemplateRelationship | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationAgeDaysConfiguration | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationConfiguration | Non-Identifying | One To Zero or More | NO | ||||
| StudentSubsidiaryAccountTransaction | Non-Identifying | One To Zero or More | NO | ||||
| SubsidiaryAccountTypeCampusDetail | Non-Identifying | One To Zero or More | NO | ||||
| SaTransCourseAmount | Non-Identifying | One To Zero or More | NO | ||||
| SaTuitionDiscountOrder | Non-Identifying | One To Zero or More | NO | ||||
| StudentServicesLocation | Non-Identifying | One To Zero or More | NO | ||||
| SyAdvancedSearchSavedCriteria | Non-Identifying | One To Zero or More | NO | ||||
| CampusDefaultStudentAdvisor | Identifying | One To Zero or More | NO | ||||
| AutomatedBusinessProcess | Non-Identifying | One To Zero or More | NO | ||||
| SyBatchRegulatory | Non-Identifying | One To Zero or More | NO | ||||
| SyCampusADPaths | Non-Identifying | One To Zero or More | NO | ||||
| SyCampusAutoAddCourseSection | Non-Identifying | One To Zero or More | NO | ||||
| CampusAutoAwardSetting | Identifying | One To Zero or More | NO | ||||
| CampusCrossRegistrationGroup | Non-Identifying | One To Zero or More | NO | ||||
| CampusCrossRegistrationGroup | Non-Identifying | One To Zero or More | NO | ||||
| CampusDetail | Identifying | One To Zero or More | NO | ||||
| SyCampusECodes | Identifying | One To Zero or More | NO | ||||
| SyCampusEmails | Non-Identifying | One To Zero or More | NO | ||||
| syCampusExternalMap | Non-Identifying | One To Zero or More | NO | ||||
| CampusLmsVendor | Non-Identifying | One To Zero or More | NO | ||||
| SyCampusTransferCreditStatus | Non-Identifying | One To Zero or More | NO | ||||
| SyCODDirectLoanEntity | Non-Identifying | One To Zero or More | NO | ||||
| SyExceptionMessages | Non-Identifying | One To Zero or More | NO | ||||
| syIMSConfiguration | Non-Identifying | One To Zero or More | NO | ||||
| syIMSExtension | Non-Identifying | One To Zero or More | NO | ||||
| syIMSExtensionStructure | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessException | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionTypeCampusTemplate | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionCustomActionDocumentReview | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionOverrideUserAssociation | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceExceptionQueue | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionResolutionGroupCampus | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceExceptionRoutingDocumentRelationship | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessSourceRecord | Non-Identifying | One To Zero or More | NO | ||||
| BusinessProcessSubscriptionDetail | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessRecipientMailBoxCommonlineAssociation | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessRecipientMailBoxBusinessProcessTypeAssociation | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceSTARExceptionQueue | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceSubscriptionExceptionRoutingRelationship | Non-Identifying | One To Zero or More | NO | ||||
| SevisCampusDetail | Non-Identifying | One To Zero or More | NO | ||||
| SevisStudentSiteActivity | Non-Identifying | One To Zero or More | NO | ||||
| StateReportCampusSetting | Non-Identifying | One To Zero or More | NO | ||||
| ProspectInquiry | Non-Identifying | One To Zero or More | NO | ||||
| SyUserFormLog | Non-Identifying | One To Zero or More | NO | ||||
| wpCampusSettings | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentPeriodTransfer | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentPeriodTransfer | Non-Identifying | One To Zero or More | NO |
| Campus Check Constraints |
| Check Constraint Name | CheckConstraint |
| Campus Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.Campus |
NO | |||
| Physical (Microsoft SQL Server) dbo.SyCampus |
NO |
| Campus Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Applicant_Enroll |
| Logical | ElectronicPaymentProcessing |
| Logical | Employers |
| Logical | Grades/Attendance |
| Logical | Incidents |
| Logical | LedgerCard_Billing |
| Logical | PreviousEd_TransferCredits |
| Logical | Prospect |
| Logical | RefundCalculation |
| Logical | SEVIS |
| Logical | StudentEnrollment |
| Logical | SubsidiaryLedger |
| Logical | TestScores |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Academic Records |
| Physical (Microsoft SQL Server) | System |
| Campus Data Movement Rules |
| Name | Type | Rule Text/Value |